﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.OleDb;
using Capstone_project.DatabaseAccessLayer;

namespace Capstone_project.BussnessLogicLayer
{
    class User_taskBUS
    {
        ConnectData connData = new ConnectData();
        public DataTable getList()
        {
            string sql = "SELECT USER_TASK.USER_NAME, USER_TASK.START_DATE, USER_TASK.END_DATE, USER_TASK.DESCRIPTION FROM USER_TASK WHERE USER_TASK.ID_TASK='AFD'";
            return connData.getData(sql, true);
        }
        public string nextID()
        {
            string lastID = connData.getLastID("USER_TASK", "ID_USER_TASK").Trim();
            return Common.NextID(lastID, "UT");
        }
    }
}
